package com.demo.controller;


import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.demo.common.QueryPageParam;
import com.demo.common.Result;
import com.demo.entity.Menu;
import com.demo.entity.User;
import com.demo.service.MenuService;
import com.demo.service.UserService;
import org.apache.ibatis.javassist.compiler.ast.Variable;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.HashMap;
import java.util.List;

/**
 * <p>
 *  前端控制器
 * </p>
 *
 * @author yms
 * @since 2023-05-30
 */
@RestController
@RequestMapping("/user")
public class UserController {
    @Autowired
    private UserService userService;

    @Autowired
    private MenuService menuService;

    @GetMapping("/list")
    public List<User> list(){
        return userService.list();
    }

    //通过no查询
    @GetMapping("/findByNo")
    public Result findByNo(@RequestParam String no){
        List list=  userService.lambdaQuery().eq(User::getNo,no).list();
        return list.size()>0?Result.suc(list):Result.fail();
    }

    //新增
    @PostMapping("/save")
    public Result save(@RequestBody User user){
        return userService.save(user)?Result.suc():Result.fail();
    }
    //更新
    @PostMapping("/update")
    public Result update(@RequestBody User user) {
        return userService.updateById(user) ? Result.suc() : Result.fail();
    }
    //删除
    @GetMapping("/del")
    public Result del(@RequestParam String id) {
        return userService.removeById(id) ? Result.suc() : Result.fail();
    }
    //登录(根据账户 密码进行登录）
    @PostMapping("/login")
    public Result login(@RequestBody User user) {
        List list=userService.lambdaQuery()
                .eq(User::getNo,user.getNo())
                .eq(User::getPassword,user.getPassword()).list();

        if( list.size() >0){
            User user1=(User) list.get(0);
            List MenuList=  menuService.lambdaQuery().like(Menu::getMenuright,user1.getRoleId()).list();
            HashMap res=new HashMap();
            res.put("user",user1);
            res.put("menu",MenuList);
            return Result.suc(res);
        }

        return  Result.fail();
    }




    //修改
    @PostMapping("/mod")
    public boolean mod(@RequestBody User user){
        return userService.updateById(user);
    }
    //新增或修改
    @PostMapping("/saveOrMod")
    public boolean saveOrMod(@RequestBody User user){
        return userService.saveOrUpdate(user);
    }
    //删除
    @GetMapping("/delete")
    public boolean delete(Integer id){
        return userService.removeById(id);
    }
    //查询(模糊like、匹配eq)
    @PostMapping("/listP")
    public Result listP(@RequestBody User user){
        LambdaQueryWrapper<User> lambdaQueryWrapper =new LambdaQueryWrapper();
        if (StringUtils.isNotBlank(user.getName())){
            lambdaQueryWrapper.like(User::getName,user.getName());
        }
        //lambdaQueryWrapper.like(User::getName,user.getName());
        return  Result.suc(userService.list(lambdaQueryWrapper));
    }

    //实现分页
    @PostMapping("/listPage")
    //public List<User> listPage(@RequestBody HashMap map){
    public List<User> listPage(@RequestBody QueryPageParam query){
        HashMap parpam = query.getParpam();
        String name=(String)parpam.get("name");
        System.out.println("name==="+(String)parpam.get("name"));
        //System.out.println(query);
        //System.out.println("num==="+(String)map.get("pageSize"));
        //System.out.println("num==="+query.getPageNum());
        //System.out.println("size==="+query.getPageSize());

        /*HashMap parpm=query.getParpam();
        System.out.println( "num==="+(String)parpm.get("name"));
        System.out.println( "no==="+(String)parpm.get("no"));*/

        /*LambdaQueryWrapper<User> lambdaQueryWrapper =new LambdaQueryWrapper();
        //lambdaQueryWrapper.like(User::getName,user.getName());
        lambdaQueryWrapper.eq(User::getName,user.getName());
        return userService.list(lambdaQueryWrapper);*/

        Page<User> page=new Page();
        page.setCurrent(query.getPageNum());
        page.setSize(query.getPageSize());

        LambdaQueryWrapper<User> lambdaQueryWrapper =new LambdaQueryWrapper();
        lambdaQueryWrapper.like(User::getName,name);

        IPage result = userService.page(page, lambdaQueryWrapper);
        System.out.println("total=="+result.getTotal());
        return result.getRecords();
    }

    //自定义SQL 使用Wrapper实现分页
    @PostMapping("/listPageC")
    public List<User> listPageC(@RequestBody QueryPageParam query){
        HashMap parpam = query.getParpam();
        String name=(String)parpam.get("name");
        System.out.println("name==="+(String)parpam.get("name"));
        Page<User> page=new Page();
        page.setCurrent(query.getPageNum());
        page.setSize(query.getPageSize());
        LambdaQueryWrapper<User> lambdaQueryWrapper =new LambdaQueryWrapper();
        lambdaQueryWrapper.like(User::getName,name);
        //IPage result = userService.pageC(page);
        IPage result = userService.pageCC(page,lambdaQueryWrapper);
        System.out.println("total=="+result.getTotal());
        return result.getRecords();
    }
    @PostMapping("/listPageC1")
    public Result listPageC1(@RequestBody QueryPageParam query){
        HashMap parpam = query.getParpam();
        String name=(String)parpam.get("name");
        String sex=(String)parpam.get("sex");
        String   roleId=(String)parpam.get("roleId");
        Page<User> page=new Page();
        page.setCurrent(query.getPageNum());
        page.setSize(query.getPageSize());

        LambdaQueryWrapper<User> lambdaQueryWrapper =new LambdaQueryWrapper();
        if (StringUtils.isNotBlank(name)&& !"null".equals(name)){
            lambdaQueryWrapper.like(User::getName,name);
        }
        if (StringUtils.isNotBlank(sex)){
            lambdaQueryWrapper.eq(User::getSex,sex);
        }
        if (StringUtils.isNotBlank(roleId)){
            lambdaQueryWrapper.eq(User::getRoleId,roleId);
        }


        //IPage result = userService.pageC(page);
        IPage result = userService.pageCC(page,lambdaQueryWrapper);
        System.out.println("total=="+result.getTotal());
        return Result.suc(result.getRecords(),result.getTotal());
    }
}
